Type property as it applies to the CommandBar object.
Returns the type of command bar. Read-only MsoBarType.
MsoBarType can be one of these MsoBarType constants. |
msoBarTypeMenuBar |
msoBarTypeNormal |
msoBarTypePopup |
expression.Type
expression Required. An expression that returns a CommandBar object.
Returns the type of command bar control. Read-only MsoControlType.
MsoControlType can be one of these MsoControlType constants. |
msoControlActiveX |
msoControlAutoCompleteCombo |
msoControlButton |
msoControlButtonDropdown |
msoControlButtonPopup |
msoControlComboBox |
msoControlCustom |
msoControlDropdown |
msoControlEdit |
msoControlExpandingGrid |
msoControlGauge |
msoControlGenericDropdown |
msoControlGraphicCombo |
msoControlGraphicDropdown |
msoControlGraphicPopup |
msoControlGrid |
msoControlLabel |
msoControlLabelEx |
msoControlOCXDropdown |
msoControlPane |
msoControlPopup |
msoControlSpinner |
msoControlSplitButtonMRUPopup |
msoControlSplitButtonPopup |
msoControlSplitDropdown |
msoControlSplitExpandingGrid |
msoControlWorkPane |
expression.Type
expression Required. An expression that returns one of the above objects.
Type property as it applies to the SearchScope object.
Returns a value that corresponds to the type of SearchScope object. The type indicates the area in which the Execute method of the FileSearch object will search for files. Read-only MsoSearchIn.
MsoSearchIn can be one of these MsoSearchIn constants. |
msoSearchInCustom |
msoSearchInMyComputer |
msoSearchInMyNetworkPlaces |
msoSearchInOutlook |
expression.Type
expression Required. An expression that returns a SearchScope object.
Type property as it applies to the DocumentProperty object.
Returns or sets the document property type. Read-only for built-in document properties; read/write for custom document properties.
expression.Type
expression Required. An expression that returns a DocumentProperty object.
The return value will be a MsoDocProperties constant.
MsoDocProperties can be one of these MsoDocProperties constants. |
msoPropertyTypeBoolean |
msoPropertyTypeDate |
msoPropertyTypeFloat |
msoPropertyTypeNumber |
msoPropertyTypeString |
As it applies to the CommandBar object.
This example finds the first control on the command bar named Custom. Using the Type property, the example determines whether the control is a button. If the control is a button, the example copies the face of the Copy button (on the Standard toolbar) and then pastes it onto the control.
Set oldCtrl = CommandBars("Custom").Controls(1)
If oldCtrl.Type = msoControlButton Then
Set newCtrl = CommandBars.FindControl(Type:= _
MsoControlButton, ID:= _
CommandBars("Standard").Controls("Copy").ID)
NewCtrl.CopyFace
OldCtrl.PasteFace
End If
As it applies to the DocumentProperty object.
This example displays the name, type, and value of a document property. You must pass a valid DocumentProperty object to the procedure.
Sub DisplayPropertyInfo(dp As DocumentProperty)
MsgBox "value = " & dp.Value & Chr(13) & _
"type = " & dp.Type & Chr(13) & _
"name = " & dp.Name
End Sub